idaClose

idaConnect

These functions are used to open or close an existing IDA database connection.

idaConnect, idaClose

Functionality required to efficiently use R with IBM(R) Db2(R)
Warehouse offerings (formerly IBM dashDB(R)) and IBM Db2 for z/OS(R) in
conjunction with IBM Db2 Analytics Accelerator for z/OS.
Many basic and complex R operations are pushed down into the database,
which removes the main memory boundary of R and allows to make full
use of parallel processing in the underlying database.
For executing R-functions in a multi-node environment in parallel the idaTApply() function
requires the 'SparkR' package (<https://spark.apache.org/docs/latest/sparkr.html>).
The optional 'ggplot2' package is needed for the plot.idaLm() function only.

Toni Bollinger

ibmdbR

IBM in-Database Analytics for R

Shaikh Quader

Ming-pang Wei

Alexander Eckert

Michael Wurst

Craig Blaha

IBM Corporation 

idaConnect, idaClose function

<dl> <dt>dsn</dt>
<dd>The DSN of the data base.</dd> <dt>uid</dt>
<dd>The user name.</dd> <dt>pwd</dt>
<dd>The password.</dd> <dt>conType</dt>
<dd>The connection type.</dd>
 
 <dt>dsnLookup</dt>
<dd>This parameter only is used when ibmdbR is loaded in an RStudio instance of IBM Data Science Experience. Per default ("auto") ibmdbR automatically detects if the provided dsn value is an usual DSN string or the name of a connection in the local connection store. The lookup method can also be manually set to "default", if the dsn parameter should be treated as an usual DSN string. If set to "store" the connection store of RStudio on DSX will be used.</dd> <dt>...</dt>
<dd>Additional arguments for DSN lookup.</dd> <dt>idaConn</dt>
<dd>The connection object.</dd></dl>

Arguments

Open or closes a IDA database connection — idaConnect, idaClose

<dl>

 <dt>dsn</dt>
<dd>The DSN of the data base.</dd>

 <dt>uid</dt>
<dd>The user name.</dd>

 <dt>pwd</dt>
<dd>The password.</dd>

 <dt>conType</dt>
<dd>The connection type.</dd>
 
 <dt>dsnLookup</dt>
<dd>This parameter only is used when ibmdbR is loaded in an RStudio instance of IBM Data Science Experience. Per default ("auto") ibmdbR automatically detects if the provided dsn value is an usual DSN string or the name of a connection in the local connection store. The lookup method can also be manually set to "default", if the dsn parameter should be treated as an usual DSN string. If set to "store" the connection store of RStudio on DSX will be used.</dd>

 <dt>...</dt>
<dd>Additional arguments for DSN lookup.</dd>

 <dt>idaConn</dt>
<dd>The connection object.</dd>

</dl>

Open or closes a IDA database connection

idaConnect, idaClose: Open or closes a IDA database connection

Description

Usage

Arguments

Details

Examples